Tabela ServiceComponentMap

Definicja tabeli ServiceComponentMap

Name

ServiceComponentMap

Code

ServiceComponentMap

Comment

Powiazanie ze skladnikiem uslugi


Lista kolumn tabeli ServiceComponentMap

Name

Code

ServiceComponentMapID

ServiceComponentMapID

ServiceComponentID

ServiceComponentID

ComponentTypeID

ComponentTypeID

StartDT

StartDT

StopDT

StopDT

Identifier

Identifier


Kolumna ServiceComponentMapID tabeli ServiceComponentMap

Definicja kolumny ServiceComponentMapID tabeli ServiceComponentMap

Name

ServiceComponentMapID

Code

ServiceComponentMapID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServiceComponentID tabeli ServiceComponentMap

Definicja kolumny ServiceComponentID tabeli ServiceComponentMap

Name

ServiceComponentID

Code

ServiceComponentID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ComponentTypeID tabeli ServiceComponentMap

Definicja kolumny ComponentTypeID tabeli ServiceComponentMap

Name

ComponentTypeID

Code

ComponentTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli ServiceComponentMap

Definicja kolumny StartDT tabeli ServiceComponentMap

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StopDT tabeli ServiceComponentMap

Definicja kolumny StopDT tabeli ServiceComponentMap

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Identifier tabeli ServiceComponentMap

Definicja kolumny Identifier tabeli ServiceComponentMap

Name

Identifier

Code

Identifier

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli ServiceComponentMap

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ServiceComponentMap

Definicja klucza Identifier_1 tabeli ServiceComponentMap

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment